I have been trying for ages to solve this problem for some time. I have a worksheet called Channels which contains 2 columns Column 1 ChannelName and Column 2 URL_Location. I need to copy the values to a new sheet to create a M3u file and the data needs to be alternated as follows.

>ChannelName

>Url_Location

>Channel_Name

>URLLocation

I have placed the formula in the new sheet (Name is M3u) as follows

>Cell A1 has the formula ='Channels'!A1

>Cell A2 has the formula ='Channels'!B1

I then select both the above cells and try to drag the formula down so it would be

>Cell A1 has the formula ='Channels'!A1

>Cell A2 has the formula ='Channels'!B1

>Cell A3 has the formula ='Channels'!A2

>Cell A4 has the formula ='Channels'!B2

>Cell A5 has the formula ='Channels'!A3

>Cell A6 has the formula ='Channels'!B3

>Cell A7 has the formula ='Channels'!A4

>Cell A8 has the formula ='Channels'!B4


BUT what happens is that I end up with the following formula....

>Cell A1 has the formula ='Channels'!A1

>Cell A2 has the formula ='Channels'!B1

>Cell A3 has the formula ='Channels'!A3

>Cell A4 has the formula ='Channels'!B3

>Cell A5 has the formula ='Channels'!A5

>Cell A6 has the formula ='Channels'!B5

>Cell A7 has the formula ='Channels'!A7

>Cell A8 has the formula ='Channels'!B7

I have tried adding an extra column with alternate 1 & 0 then filtering the result to show each alternate row, then copy and past to visible only rom but the formula still jumps 2 values instead of 1.

Is there a very simple formula or copy & past solution or do I need to use VB code. If you could provide a detailed answer that would be SUPER appreciated.