0 - 6 of 6 tags for pivot

Good day all,
I have data that consists of 3 months of charges for each line item.
Bill_No                Bill_Month                     Charge
00121       4/10/2015 12:00:00 AM           1300.00
00121       5/10/2015 12:00:00 AM           1300.00
00121      6/10/2015 12:00:00 AM            1400.00
 

General format of pivot...
SELECT * FROM pivot(

ON { table_name | view_name | ( query ) }

PARTITION BY col1[, col2, ...]

[ ORDER BY order_by_columns ]

PARTITIONS('col1'[, 'col2', ...])

ROWS('number_of_rows')

PIVOT_KEYS('key1', 'key2'[, ...])

PIVOT_COLUMN( 'pivot_column_name' )

Hi All,

I'm new to TD and need help converting rows into a single column; 

 

Sample input data.

 

ID   key2 Indicator  

123 ABC    A1

123 ABC    B1

123 ABC    C1

345 CDE    A1

345 CDE    B1

345 CDE    C1

567 XYZ     B1

567 XYZ     C1

 

Hi All,
I'm new to TD. I need to transpose data from rows to columns. I'm not sure how to do it using PIVOT in teradata. Can anyone help me.
Sample input data.
ID Name English Maths Science
123 ABC   90       95       95
345 CDE   70       80       90
 
My output should look like,

HI,
I NEED TO DO A ROWCOUNT ON ALL TABLES ON A GIVEN DATABASE. I CAN EASILY DO THIS IN SQL USING A PIVOT TABLE.

CAN SOMEONE HELP?

THIS IS WHAT I HAVE:
LETS SAY THIS IS (TABLE_COUNTS)

TABLENAMES ROWCOUNTS
TABLE1 500
TABLE2 200
TABLE3 800
TABLE4 499