How to create a table from text?

[mrutledge]

I'm attempting to create a 5 column, 1001 row table from a text file that is separated by line breaks.

EX:
Header 1
Header 2
Header 3
Header 4
Header 5
Table Row 1a
Table Row 1b
Table Row 1c
Table Row 1d
Table Row 1e
Table Row 2a
etc.

I've been searching for hours and can't seem to find a way to do so without the table elements being separated by commas.

Could anyone share their knowledge and help me out? I'd greatly appreciate it.

[oeldere]

Probably, you need a VBA solution.

But you get better result on your question, if you add a small excel file, without confidential information.

Please also add the expected result in your file.

[rajeesh_k]

You can convert the text to spreadsheet format by using text to column option under data menu.

after the table creation will be easier

please attach a sample sheet