Forum Discussion
VBA Data Import
Looking for VBA code to parse a list. The list is an extract of a music playlist which retains the Line 1 "name of song", skips the second line which is a repeat of Line 1. Line 3: Retains Artist na...
In general that could be done by formula
=VSTACK(
{"Song","Artist","Album","Time"},
IFNA(CHOOSECOLS(WRAPROWS(Playlist,5),{1,3,4,5}),"")
)