This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Little bit of work to rework the data, but here you go - I've done it for you.
Text to columns a few times...
First to split on the new rows all the way down the second to split them on the tabs and get them into separate columns. Little data cleanse to remove some white-space, drop the fields we don't need, and a dynamic rename to get the headers.
I've gone ahead and done both examples you've asked for (the only difference is the number of columns to split into).
Might I suggest you try to make a MACRO that asks for how many columns to split into and package this up for yourself?