PDA

View Full Version : Copy data in corresponding cells



ksp
08-20-2015, 03:25 AM
hi, I have copied data from a pdf file into excel and all the data is copied into cell A (300 entries)
Data is copied like below uptil 300 lines.

Card Activation
8/5/2015 11:15:45
Card Entry

I would like the data to be copied in adjacent cells in one row. Since the data when moved will create empty cells, those rows should be deleted. It should loop down to the last entry.

Card Activation 8/5/2015 11:15:45 Card Entry

The second line is always a date/time format and the last since always starts with Card Entry apart from other data in that cell.