How to Split Alt Enter Column Data into Separate Rows with respect to Row A..

[AhmedExperts]

Hello Guys, Please help me.. I have large data in Excel sheet in following format

A	32423 2234325	12131	11231 2534R 323422		1245 224241	112125 21212 353453 464363 545352						12423	123525 22424
B		114343	12342 2E23R	1342	1423R 25346	1324				1234 2525		1234 2522

<tbody>
</tbody>

I want to convert this data to this format..

A	32423	12131	11231		1245	112125						12423	123525
A	2234325		2534R		224241	21212							22424
A			323422			353453
A						464363
A						545352
B		114343	12342	1342	1423R	1324				1234		1234
B			2E23R		25346					2525		2522
B					33452

<tbody>
</tbody>

Please help me to convert data in above format. I want each entry in single column with First Column ,, Thanks in advance..

 

[yky]

This is an interesting problem. I'd like to know how many rows and columns are in the file.

Alternatively, if you have or have access to OmniPage, you can save the file in PDF format and have OmniPage to OCR it.

 

[Rick Rothstein]

This is an interesting problem. I'd like to know how many rows and columns are in the file.

To follow up on yky's question, I have one as well... Are the stacked values all in single normal cells or are they in a merged cells? In other words, is the first table composed of Rows 1 and 2 or are they various merged sets of cells occupying Rows 1 to 7?