Escanaba
asked on
Excel 2007 Macro to Take Row of Text and Place in Single Column
Hello -
Hoping someone can assist in developing a code that will essentially un-pivot text in rows. Difficult to explain but when you see the attached sample it will hopefully make more sense. The purpose of this is to generate a word cloud graphic in different software but in order to accomplish it I need the text in each row to line up in a single column notated by identifiers in columns A & B.
Again, best way to get across what I'd like the code to do is to look at the sample. The 'Raw Data' worksheet shows how it appears once the extract takes place and the 'Should Look After Macro' is how the data should look after the code is ran.
Any support would be greatly appreciated!
EE-Sample.xlsx
Hoping someone can assist in developing a code that will essentially un-pivot text in rows. Difficult to explain but when you see the attached sample it will hopefully make more sense. The purpose of this is to generate a word cloud graphic in different software but in order to accomplish it I need the text in each row to line up in a single column notated by identifiers in columns A & B.
Again, best way to get across what I'd like the code to do is to look at the sample. The 'Raw Data' worksheet shows how it appears once the extract takes place and the 'Should Look After Macro' is how the data should look after the code is ran.
Any support would be greatly appreciated!
EE-Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER