Challenge #53: Parsing Report Formatted Data

[Ajjay]

Spoiler

[Samanthaj_hughes]

I went Macro on this one, to keep the tool count down, plus better flexibility for picking columns / delimiter if necessary.

[ExploreMore]

Spoiler

 

[ncrlelia]

Challenge 053

[ARussell34]

Here is my solution for 53!

[Elias_Nordlinder]

Here is my solution 🙂

Edit: Missed that it should be dynamic.
Remade the whole workflow to work with the required things now!

Spoiler

[Emil_Kos]

Hi,

I am getting to know more and more about macros 😀

[Samanthaj_hughes]

Not sure this is the smallest amount of tools but its a very logical way to solve with notes 😉

[Kevin_VANCAPPEL]

Hello,

  here is my proposal.

  Regards

  Kévin V.

[DanTh]

Not sure why Split to Rows wouldn't handle the dynamic number of columns? 

Spoiler

Assumptions are that the extra rows are all "-----" etc. and that the #s need to become N/As. Combination of Split to Rows and the Tile block to handle the dynamic columns. Dropping a mark for not attempting the Macro.
4/5