Ok, well you'll want to split the number out of the string first then. If your data is always going to be in the same format, this makes it a...

What do you define as the highest number in your example, 9 or 348? Will your strings always be in the format of XXX000? What have you tried so far?

Fairly simple this one.
DECLARE @Quarters int = 0;
SELECT DATEADD(QUARTER,DATEDIFF(QUARTER,0,GETDATE()) + @Quarters,0);
The value of Quarters can be changed to be a positive or negative integer....

I was honestly wondering how long it would be before you came along with a Cross Tab style query, Luis. 😉

One option is using UNPIVOT (Using PIVOT and UNPIVOT). For example:
USE TestDB;
GO

CREATE TABLE SampleTable (RandomDate date);
GO

INSERT INTO SampleTable

Although this doesn't work for string literals, it works fine when using a dataset. For example:
CREATE TABLE #test (string varchar(20));
GO

INSERT INTO #test
VALUES ('LOHAUANIA');

I notice your dates in your data are in the format ddMMMMyyyy. Is this actually how they are stored; are you using a varchar to store them?

Can we...