I am looking for help to Index & Match and return a range as this example:
A B C D E F G
12 1 GER - FRA - - SWE - NOR -
13 2 JPN - AUS SCO - USA - - BEL - SUI -
14 3 - - - KOR - WAL - -
I wish to match say the number 2 (A13) or any number in col A and all the data in line 13 or all the data opposite whatever number is chosen and it would be copied over as say GER - FRA (with the "dash") and all the data in that row and if possible have a comma "," between the double names or a "space" or even two spaces. .
If the row is blank I would like the cell to be "" .
I do hope you can follow my request and many thanks for looking.