admin2220Copper ContributorAug 07, 2024Excel How do I change rows to columns when I have one very long row of data and 3 shorter lines of data in Excel?
HansVogelaarMVPAug 07, 2024admin2220 Perhaps a formula such as =LET(t, TRANSPOSE(A1:ZZ4), IF(t="", "", t))