Merge rows

[trailfarley]

I have this data set and trying to remove the column headers and make the first row be "Per DAI" all the way across the dataset, as a merged cell. Is it possible?

[smarcucci]

Hi buddy,

I'm 99% sure you can't merge columns in Alteryx, that's more an excel functionality. The closest you could get is having all the columns named "Per DAI".
Regarding dropping the first row of data, there are multiple ways you could achieve this, the easiest I can think of is using a sample tool, configured as in the attached image.

Best,
Tucu