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: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.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.

Participant

Question

Data Merge Conundrum, HELP!!!

Forum|Forum|11 months ago
April 22, 2025
2 replies
313 views

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:

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.
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.

V1_totals_25_doors_Master.xlsx

V1_totals_25_doors_Master.csv

Pages_from_V1_Stickers.pdf

Robert at ID-Tasker

Legend

@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.