Formatting Uploaded Data

Hi rajibmahmud,

In the Query Editor select the Quarter column and then Pivot columns and select the Value column in the options you will get the desired result:

Regards,

MFelix

Hi rajibmahmud,

You can do this in one of two ways in the query editor:

1 - Create a new column with a text like this:

Column "TEXT" & [Column]

Then delete the previous column and keep this

This can be done by the column from example and it pretty easy to achieve:

2 - Do a Replace in the specific column for the text that you want to add:

If all your rows start with 1 you can do a replace of 1 for Text1

Regards,

MFelix