Moving Data in an excel Sheet

I am having a problem with the initial format of a report I'm inputting into my workflow. Data that I need is at the top of the sheet but I need to add that data to a column that applies to each row of the sheet. After I do that I also need to have the sheet be read as a table with the headings on row 7 as fields for data merging. Any Ideas?

ExampleWebinarSheet.PNG

Workflow

Input

Accepted answers

Claje

Making some assumptions about your data here, and creating an example workflow that should do roughly what you want, although it might need some tweaks.

Let me know if you have any questions about the screenshot above and I will try to add more context. I used a dummy file that this example doesn't work for, so I don't want to share the broken workflow I'm using

If you provide a small sample set (like whats in your Webinar image) I can upload it.

All comments

Claje

Making some assumptions about your data here, and creating an example workflow that should do roughly what you want, although it might need some tweaks.

AlexStewart628

Here's the sample set of data I made the screenshot of.

SampleWebinar.xlsx

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335