This is my first post so my apologies if not done correctly.
I am trying to figure out how to get multiple rows of data combined into one row and then being able to sort that data.
I have attached a f showing how I need them combined however the output probably needs to be in another tab so I can sort. The spreadsheets will also have rows in there that do not need to be combined but need to be part of the output that is sortable.
Excel Forum Example Sheet.xlsx
Are the bold rows the required output? You only need the bold rows to show up in another sheet?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Correct the bold is the output and what I need to show in another sheet to be able to sort.
One last question - will there always be 2 records per campaign?
It will most likely be 2 campaigns but there are a few that might have more.
How can I convert one row to multiple rows?
a b c d e f g h i j k l
to
a b c d
e f g h
i j k l
pnarula,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks