Forum Discussion
How to make a headline in Excel for table?
So basically what I would like is to link together 4 or so cells that have the same headline. In this case link A till D under one headline 'Cars' that covers the 4 cells instead of four times 'Cars...
Doesn't make sense what you are trying to do. Below formula will generate 4 times cars from A1 to D1
=INDEX("Cars",1,SEQUENCE(1,4,1,0))
I probably could've formulated it a bit clearer. I wanted to merge cells.