Hi
I have Sales Data in column A and Column B
Now, I want to Transpose Column B Based on Column A
See the Attached with Expected Result
Regards
Hardeep kanwar
Hi
I have Sales Data in column A and Column B
Now, I want to Transpose Column B Based on Column A
See the Attached with Expected Result
Regards
Hardeep kanwar
Last edited by hardeep.kanwar; 03-29-2010 at 12:27 AM. Reason: Not Attached the File
How many items will there be for each Data1, Data2, etc. Will the second column be text or numbers?
The data sample is not very representative of sales data, which would normally involve something like product name, sales person, date of sale, amount of sale etc, but not just two columns with text values.
Can your revisit your data sample and come up with something that represents the situation more accurately?
How about this?
Just format cells as column name:
hardeep, maybe you need to take a step back and explain what you want to achieve in the first place. This looks like a piece of a puzzle that's a bit bigger than you let on.
Are you sure you do not have any numeric data that will go with the text you listed?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks