I need to simplify manual work of copy paste and need to copy the value which is written above "ports" ( only constant value in the excel table) and paste it next to the port numbers. Below is a sample.
original table - consider the below to be in the same column.
10.10.10.1
ports
23
22
44
334
10.10.10.2
ports
44
56
80
164
result required- two columns
ports
10.10.10.1 23
10.10.10.1 22
10.10.10.1 44
10.10.10.1 334
ports
10.10.10.2 44
10.10.10.2 56
10.10.10.2 80
10.10.10.2 164
Please suggest
Bookmarks