decadence
02-01-2016, 04:02 AM
Good Morning all,
I need a macro to combine any columns I select into one column, so if I chose columns A,B,C,D then all data from these columns will be merged into column A with a space, or if I selected Columns D to T then all data from columns D to T would be merged into column D with a space,
Each column must keep the original data on the same row and the columns originally selected are deleted after merging.
Each Column will have varied data with different number of rows
Headers are to be included with this merge
I am using Excel 2007
(the dots are only used to break up the words into columns)
Example
......A........ B........ C........ D......... E
1 Hi.........How......Are......You......Hello
2 ........... How
3 ....................... Are
4 .................................. You
Merged to this
...............A....................B..........C.......D.......E....
1 Hi How Are You..........Hello
2 How
3 Are
4 You
Any help is appreciated,
Thanks in advance
I need a macro to combine any columns I select into one column, so if I chose columns A,B,C,D then all data from these columns will be merged into column A with a space, or if I selected Columns D to T then all data from columns D to T would be merged into column D with a space,
Each column must keep the original data on the same row and the columns originally selected are deleted after merging.
Each Column will have varied data with different number of rows
Headers are to be included with this merge
I am using Excel 2007
(the dots are only used to break up the words into columns)
Example
......A........ B........ C........ D......... E
1 Hi.........How......Are......You......Hello
2 ........... How
3 ....................... Are
4 .................................. You
Merged to this
...............A....................B..........C.......D.......E....
1 Hi How Are You..........Hello
2 How
3 Are
4 You
Any help is appreciated,
Thanks in advance