This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
First thing you have to do is to create a field that will differentiate data between store 1 and 2. As data for stores 1&2 come in sequence, you can do that by first assigning a record ID in each row and then using the modulo function to group them in stores 1 & 2.
Then you can use a cross-tab tool to bring your data in the desired format
Let me know if you have any questions. Hope that helps.