faizal Izham
New Member
- Joined
- Oct 26, 2017
- Messages
- 7
I would like to seek help from the expert in Mr.Excel with my issue below.
i have some sample data as per below. Host is in 1 table and Port is on another table.
<tbody>
</tbody>
I would like to output the data as per below in another sheet.
<tbody>
</tbody>
Below is other sample on the data.
<tbody>
</tbody>
<tbody>
</tbody>
If the Column in Port is empty it will skipped to the next host and loop with the available port.
<tbody>
</tbody>
Hope someone can help me with the formula to automatically loop around the data.
Thank You in advance for helping.
i have some sample data as per below. Host is in 1 table and Port is on another table.
Host | Port1 | Port2 | Port3 | |
Host1 | 1A | 1B | 1C | |
Host2 |
<tbody>
</tbody>
I would like to output the data as per below in another sheet.
Host | Output |
Host1 | Host1_1A |
Host1 | Host1_1B |
Host1 | Host1_1C |
Host2 | Host2_1A |
Host2 | Host2_1B |
Host2 | Host2_1C |
<tbody>
</tbody>
Below is other sample on the data.
<tbody>
</tbody>
Host | Port1 | Port2 | Port3 | |
Host1 | 1A | 1B | ||
Host2 | ||||
Host3 |
<tbody>
</tbody>
If the Column in Port is empty it will skipped to the next host and loop with the available port.
Host | Output |
Host1 | Host1_1A |
Host1 | Host1_1B |
Host2 | Host2_1A |
Host2 | Host2_1B |
Host3 | Host3_1A |
Host3 | Host3_1B |
<tbody>
</tbody>
Hope someone can help me with the formula to automatically loop around the data.
Thank You in advance for helping.