CODEWITHSUNDEEP
vbaexcel
Aslaam
Aslaam

Reputation: 37

Concatenate row and column titles

I am trying to populate a table with the concatenation of rows and columns titles as attached, from:

enter image description here

The problem is that number of rows and columns can change.

Upvotes: 1

Views: 626

Answers (1)

Excel Hero
Excel Hero

Reputation: 14764

There is no VBA required for this. A simple formula can do it.

Assuming that the names (Alan, James, Catherine, etc.) are in column A and that the positions are in column B and the countries are in column C.

Assuming that the years are in row 2 and the months are in row 3.

Enter the following formula into cell D4:

=$A4&";"&$B4&";"&$C4&";"&D$3&";"&D$2

Now copy D4 downward and rightward as far as you need.

That's it.

Upvotes: 1

Related Questions