Data Merge Conundrum, HELP!!!

[cmead]

I am researching a way to streamline a process. I will get a data file with up to 300 columns and over 400 rows in excel. I need a couple of things to happen:

1. Each column needs to be its own page with the corresponding rows info. For the sample, I can do this by creating separate pages and manually putting the data fileds in, but cannot do this for 300+ pages.
2. Can we have the column title (name) information show in said entry?

I have attached the pdf sample of what I am looking for, salmon highlight is Column, pale yellow is the row. I have also included the data files I am using.

Any help wouled be appreciated.

[brian_p_dts]

For issue 1, couldn't you just transpose the sheet so that rows are columns and vice versa, to make ot work with DM?

For issue two, you could add new fields to the data file reflecting the headers. 

[Robert at ID-Tasker]

@cmead

You don't need DataMerge - you can import your data as a table - after transposing it if needed - then apply separate ParaStyles to each column, then convert this table to text - with "paragraph" as a separator for columns and rows - then reflow this text into your linked TextFrames - on your sticker template.

But you'll need to prepare separate datasets anyway.