Help w/ Pivot Table

Question

Post reply

Help w/ Pivot Table

MegaDBA

Hall of Fame

Points: 3518

February 21, 2006 at 12:56 pm

#167760

Hi everyone, I need help creating this pivot table asap! Any assistance is much appreciated...

Here is the data I have currently in an excel spreadsheet:

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

13

12

11

10

9

8

7

6

5

4

3

2

Feb

2

13

12

11

10

9

8

7

6

5

4

3

Mar

3

2

13

12

11

10

9

8

7

6

5

4

Apr

4

3

2

13

12

11

10

9

8

7

6

5

May

5

4

3

2

13

12

11

10

9

8

7

6

Jun

6

5

4

3

2

13

12

11

10

9

8

7

Jul

7

6

5

4

3

2

13

12

11

10

9

8

Aug

8

7

6

5

4

3

2

13

12

11

10

9

Sep

9

8

7

6

5

4

3

2

13

12

11

10

Oct

10

9

8

7

6

5

4

3

2

13

12

11

Nov

11

10

9

8

7

6

5

4

3

2

13

12

Dec

12

11

10

9

8

7

6

5

4

3

2

13

I need to be able to return back the numbers in the columns.

So the first row represents 1st Payment Due month
And (top) Column represents Tax Bill month due in:

I need to return the value in the column...How can I represent this? This data is not currently stored in our dB...do I create a temp table storing the months? What is my first step?

Thanks in Advance!

Aurora

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 1

If you already have this table in the Excel spreadsheet, just import it in SQL Server using DTS Import Wizard specifying Excel file as a source and a new table in your database as destination.

Let us know if you need explanations on how to do that.

Regards,Yelena Varsha

MegaDBA Hall of Fame Points: 3518 More actions · Answer 2

Okay I have imported the table let me make sure it is something my developers can use...Thank you for your help and I'll keep you posted...

Christine

Aurora