Repeat header row to every row

[Waqas Gul]

Dear Team,

i have a list of rows, where if i simply copy paste the header row then it will take so much time. if there's any simple way to be repeated to header row to every row, i know the family of experts will surely simplify this for me.

note: this is not required for print setting. the header row required with every row.

attached sheet for ease.

Thanks

[MarvinP]

Hi Waqas,

If you convert your first table to what you want, it is less useful in Excel. My suggestion is don't do it!!! Instead learn more about Auto Filters or Advanced Filters to get what you want. Don't repeat the header row every other row.

Learn more about Excel Tables and why what you have is much better.
https://www.excel-easy.com/data-analysis/tables.html

[Waqas Gul]

Hi MarvinP,

Thanks for your reply and good suggestion. i can explain.
i need this for print purpose, these are actually slips and i need 20 to 30 on one page to avoid extra consumption of papers. and the simple copy paste will take so much time to paste the header row to every row. if there's any way to simplify the issue.

[Ghozi Alkatiri]

at G3
=IF(MOD(ROW(A1),2)=0,A$2,INDEX($A$3:$D$6,TRUNC(ROW(A1)/2)+1,COLUMN(A1)))
copy cross and down

Ghozi Alkatiri

[Waqas Gul]

at G3
=IF(MOD(ROW(A1),2)=0,A$2,INDEX($A$3:$D$6,TRUNC(ROW(A1)/2)+1,COLUMN(A1)))
copy cross and down

Ghozi Alkatiri

WoW!!! Ghozi Alkatiri Thank You So Much.