I have imported a txt file in to Query editor, separated in to two columns and cleansed the data to give me a data set with 31 unique row labels in column A and the information in column B. (see below) Is there a way I can transform this data within query editor to show a table of 31 rows with the column data showing in columns B onwards?
<colgroup><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col></colgroup><tbody>
</tbody>