ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need some help (https://www.excelbanter.com/excel-programming/285891-need-some-help.html)

Christopher Stern

Need some help
 
I am looking to do the following:

I want a solution or macro which will do the following:

I have data in column one but need the every other line to be cut and
pasted in column 2 one after the other then need column one empty
spaces to be deleted so data will show after the other which
corresponds with column 2.

Example:

How data comes thru now:

Data 1
Data 2
Data 1
Data 2

How I want data to show:
Data 1 Data 2
Data 1 Data 2

Thanks,
Chris


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com