Convert A Single Row to Column, with an undefined number of rows [Closed]

Report
-
Hello,

Hopefully somebody can help, I have a number of files where I need to convert the single row too columns, however the issue I have is the number of rows to covert to columns are not static, for example as per the data below is all in A1 row, I want to convert A1 - A13 as line one column, then where the blank line is should be the break point to start a new row with the next group with the contents of A15 to A29 and so on.

Current Layout

TEST NUMBER 0001
DATE 10-JUN-2016
TIME 10:39:52
TESTER 09H-1289
APP NO 0010772
TEST MODE TEST
INS >19.99 Mohm P
USER DKN
SITE Peter X B
TEXT Job 1041-68
TEXT Meeting RM
TEXT Fan
TEXT

TEST NUMBER 0002
DATE 10-JUN-2016
TIME 10:44:06
TESTER 09H-1289
APP NO 0010773
TEST MODE TEST
IEC 0.08 ohm P
INS >19.99 Mohm P
LEAD CONTINUITY P
USER DKN
SITE Peter X B
TEXT Job 1041-68
TEXT Meeting RM
TEXT ext lead
TEXT

TEST NUMBER 0003
DATE 10-JUN-2016
TIME 10:45:06
TESTER 09H-1289
APP NO 0010774
TEST MODE TEST
IEC 0.06 ohm P
INS >19.99 Mohm P
LEAD CONTINUITY P
USER DKN
SITE Peter X B
TEXT Job 1041-68
TEXT Meeting RM
TEXT iec lEAD
TEXT

What I would like to achieve in columns A - O, but note the number of lines varies but the line break and next test number are always present, and it leaves columns G and I blank when not present in the list.

TEST NUMBER 0001 DATE 10-JUN-2016 TIME 10:39:52 TESTER 09H-1289 APP NO 0010772 TEST MODE TEST INS >19.99 Mohm P USER DKN SITE Peter X B TEXT Job 1041-68 TEXT Meeting RM TEXT Fan TEXT

TEST NUMBER 0002 DATE 10-JUN-2016 TIME 10:44:06 TESTER 09H-1289 APP NO 0010773 TEST MODE TEST IEC 0.08 ohm P INS >19.99 Mohm P LEAD CONTINUITY P USER DKN SITE Peter X B TEXT Job 1041-68 TEXT Meeting RM TEXT ext lead TEXT

TEST NUMBER 0003 DATE 10-JUN-2016 TIME 10:45:06 TESTER 09H-1289 APP NO 0010774 TEST MODE TEST IEC 0.06 ohm P INS >19.99 Mohm P LEAD CONTINUITY P USER DKN SITE Peter X B TEXT Job 1041-68 TEXT Meeting RM TEXT iec lEAD TEXT

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!